Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$QUEUE

`V$QUEUE` contains information on the shared server message queues.

Column | Datatype | Description
--- | --- | ---
`PADDR` | `RAW(4 | 8)` | Address of the process that owns the queue
`TYPE` | `VARCHAR2(10)` | Type of queue: `COMMON` - Processed by servers `DISPATCHER`
`QUEUED` | `NUMBER` | Number of items in the queue
`WAIT` | `NUMBER` | Total time that all items in this queue have waited (in hundredths of a second). Divide by `TOTALQ` for average wait per item.
`TOTALQ` | `NUMBER` | Total number of items that have ever been in the queue